package com.tsinjie.metadata.database.comment;

import java.sql.Connection;
import java.sql.SQLException;

/**
 * Created by LiuXunming on 2015-10-13.
 * 获取表注释
 */
public interface TableComment {
    /**
     * mysql 查询表注释SQL语句
     */
    public static final String DATABASE_MYSQL_QUERY_COMMENT = "select TABLE_COMMENT from information_schema.TABLES  where TABLE_NAME =? AND TABLE_SCHEMA=?";

    /**
     * 获取表注释
     *
     * @param conn
     * @param tableName
     * @param schemaName
     * @return
     * @throws SQLException
     */
    String getComment(Connection conn, String tableName, String schemaName) throws SQLException;
}
